home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / r / func_set.result < prev    next >
Encoding:
Text File  |  2003-01-21  |  1.1 KB  |  19 lines  |  [TEXT/ttxt]
  1. interval(55,10,20,30,40,50,60,70,80,90,100)    interval(3,1,1+1,1+1+1+1)    field("IBM","NCA","ICL","SUN","IBM","DIGITAL")    field("A","B","C")    elt(2,"ONE","TWO","THREE")    interval(0,1,2,3,4)    elt(1,1,2,3)|0    elt(1,1.1,1.2,1.3)+0
  2. 5    2    4    0    TWO    0    1    1.1
  3. find_in_set("b","a,b,c")    find_in_set("c","a,b,c")    find_in_set("dd","a,bbb,dd")    find_in_set("bbb","a,bbb,dd")
  4. 2    3    3    2
  5. find_in_set("d","a,b,c")    find_in_set("dd","a,bbb,d")    find_in_set("bb","a,bbb,dd")
  6. 0    0    0
  7. make_set(0,'a','b','c')    make_set(-1,'a','b','c')    make_set(1,'a','b','c')    make_set(2,'a','b','c')    make_set(1+2,concat('a','b'),'c')
  8.     a,b,c    a    b    ab,c
  9. make_set(NULL,'a','b','c')    make_set(1|4,'a',NULL,'c')    make_set(1+2,'a',NULL,'c')
  10. NULL    a,c    a
  11. export_set(9,"Y","N","-",5)    export_set(9,"Y","N")    export_set(9,"Y","N","")
  12. Y-N-N-Y-N    Y,N,N,Y,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N    YNNYNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
  13. elt(2,1)    field(NULL,"a","b","c")
  14. NULL    0
  15. find_in_set("","a,b,c")    find_in_set("","a,b,c,")    find_in_set("",",a,b,c")
  16. 0    4    1
  17. find_in_set("abc","abc")    find_in_set("ab","abc")    find_in_set("abcd","abc")
  18. 1    0    0
  19.